<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_article_cat`;");
E_C("CREATE TABLE `ecs_article_cat` (
  `cat_id` smallint(5) NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(255) NOT NULL DEFAULT '',
  `cat_type` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `keywords` varchar(255) NOT NULL DEFAULT '',
  `cat_desc` varchar(255) NOT NULL DEFAULT '',
  `sort_order` tinyint(3) unsigned NOT NULL DEFAULT '50',
  `show_in_nav` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `parent_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `out_url` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cat_id`),
  KEY `cat_type` (`cat_type`),
  KEY `sort_order` (`sort_order`),
  KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_article_cat` values('1','系统分类','2','','系统保留分类','50','0','0','');");
E_D("replace into `ecs_article_cat` values('2','网店信息','3','','网店信息分类','50','0','1','');");
E_D("replace into `ecs_article_cat` values('3','网店帮助分类','4','','网店帮助分类','50','0','1','');");
E_D("replace into `ecs_article_cat` values('4','玉美人栏目','1','玉美人栏目','玉美人栏目','50','0','0','');");
E_D("replace into `ecs_article_cat` values('5','玉美人','1','玉美人','玉美人','50','1','0','');");
E_D("replace into `ecs_article_cat` values('6','玉美人配饰','1','玉美人配饰','玉美人配饰','50','1','0','');");
E_D("replace into `ecs_article_cat` values('7','玉器资讯','1','玉器资讯','玉器资讯','50','1','0','');");
E_D("replace into `ecs_article_cat` values('8','国之名企','1','国之名企','国之名企','50','0','0','');");
E_D("replace into `ecs_article_cat` values('9','栏目简介','1','栏目简介','栏目简介','50','1','4','');");
E_D("replace into `ecs_article_cat` values('10','节目内容','1','节目内容','节目内容','50','0','4','');");
E_D("replace into `ecs_article_cat` values('11','节目剧照','1','节目剧照','节目剧照','50','0','4','');");
E_D("replace into `ecs_article_cat` values('12','节目主持','1','节目主持','节目主持','50','0','4','');");
E_D("replace into `ecs_article_cat` values('13','节目美人','1','节目美人','节目美人','50','0','4','');");
E_D("replace into `ecs_article_cat` values('14','节目嘉宾','1','节目嘉宾','节目嘉宾','50','0','4','');");
E_D("replace into `ecs_article_cat` values('15','藏家故事','1','藏家故事','藏家故事','50','0','4','');");
E_D("replace into `ecs_article_cat` values('16','精彩花絮','1','精彩花絮','精彩花絮','50','0','4','');");
E_D("replace into `ecs_article_cat` values('17','玉美人资讯','1','玉美人资讯','玉美人资讯','50','0','0','');");
E_D("replace into `ecs_article_cat` values('18','关于我们','5','关于我们','关于我们','50','0','3','');");
E_D("replace into `ecs_article_cat` values('19','新手上路','5','新手上路','新手上路','50','0','3','');");
E_D("replace into `ecs_article_cat` values('20','支付方式','5','支付方式','支付方式','50','0','3','');");
E_D("replace into `ecs_article_cat` values('21','售后服务','5','售后服务','售后服务','50','0','3','');");
E_D("replace into `ecs_article_cat` values('22','视频剪辑','1','视频剪辑','视频剪辑','50','0','4','');");

require("../../inc/footer.php");
?>